Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

VisualBasic Script
1) Access
2) Application
3) Data Type
4) Data Type Functions
5) Date Functions
6) Excel
7) File Path
8) Forms
9) Language Basics
10) Math Functions
11) Outlook
12) Powerpoint
13) String Functions
14) Windows API
15) Word
16) XML

Math Functions
1) Abs() Returns the absolute value of a number
2) Abs(number) returns The absolute value of number-the unsigned magnitude of the number
3) Atn() Returns the arctangent of a number (radians)
4) Atn(number) returns The arctangent of number in radians
5) Cos() Returns the cosine of a number (radians)
6) Cos(number) returns The cosine of angle number
7) Displaying the integer part of a number
8) Exp() Returns the base e exponential of a number
9) Exp(number) returns e, the base of natural logarithms, raised to the power of number
10) Fix() Returns the integer portion of a number
11) Fix(-3 14159) returns -3
12) Fix(number) returns The integer portion of number (without rounding) If number is negative, returns the negative number gre
13) Log() Returns the natural logarithm of a number
14) Log(number) returns The natural logarithm of number
15) Rnd() Returns a random number between 0 and 1
16) Rnd([number]) returns A random number (with no argument) or a number based on the given initial seed
17) Sgn() Returns the sign of a number
18) Sgn(0) returns 0
19) Sgn(-7) returns -1
20) Sgn(number) returns -1 if number is negative, 0 if number is 0, 1 if number is positive
21) Sin() Returns the sine of a number (radians)
22) Sin(number) returns The sine of the angle specified by number (measured in radians)
23) Sqr() Returns the square root of a number
24) Sqr(number) returns The square root of number If number is negative, VBA gives a runtime error
25) Tan() Returns the tangent of a number (radians)
26) Tan(number) returns The tangent of the angle specified by number (measured in radians)
27) To prevent repetitive sequences, use the Randomize statement to initialize the random number generator with a seed value ba